USE RapPhim
GO

BEGIN TRAN
SET TRAN ISOLATION LEVEL SERIALIZABLE
	SELECT SC.MaSuatChieu,SC.MaPhim, SC.MaPhongChieu,SC.ThoiGianBatDau, SC.ThoiGianKetThuc, SC.SoLuongVe
	FROM SUATCHIEU SC
	WHERE SC.MaPhim = 1
	AND DATEDIFF(DD, SC.ThoiGianBatDau, '3/30/2012') = 0

	waitfor delay '0:0:5'
	
	--Lay danh sach suat chieu lan 2:
	SELECT SC.MaSuatChieu,SC.MaPhim, SC.MaPhongChieu,SC.ThoiGianBatDau, SC.ThoiGianKetThuc, SC.SoLuongVe
	FROM SUATCHIEU SC
	WHERE SC.MaPhim = 1
	AND DATEDIFF(DD, SC.ThoiGianBatDau, '3/30/2012') = 0
commit